Week 7

Milestones

• Fix Joda error in user Activity endpoint
• Modify query for top 10 users by overall activity endpoint according to ETL
• Modify query for users with %visits endpoint according to ETL
• Modify query for Top 5 users with most cancelled visits endpoint according to ETL

Screenshots / Videos

Canned analytics HR tab listening to all the new endpoints modified according to ETL

Contributions

• Commits

  • https://github.com/avniproject/avni-etl/commit/49db7a5b75fc39facdfb95d6539382b86f3f1f0b
  • https://github.com/avniproject/avni-etl/commit/689c7aa6a911aec813b9a464a7d3104d0f3e0d55
  • https://github.com/avniproject/avni-etl/commit/8b221c05d424c53ead895f54c84f5822e0c40829
  • https://github.com/avniproject/avni-etl/commit/49f17da72d0034eee8bc037d20489b540cce965c

Learnings

• Fixing the error in Joda - Joda date/time type org.joda.time.DateTime not supported by default: add Module "com.fasterxml.jackson.datatype:jackson-datatype-joda" to enable handling.
• Added Joda Module in build.gradle and registered it using ObjectMapper in order to fix this.
• Using schemaMetadata in order to fetch all the required tables from ETL.
• Modifying query using loops to incorporate all the changes.